<?php

require_once 'propel/map/MapBuilder.php';
include_once 'creole/CreoleTypes.php';


/**
 * This class adds structure of 'HR_EMPLOYEE' table to 'workflow' DatabaseMap object.
 *
 *
 *
 * These statically-built map classes are used by Propel to do runtime db structure discovery.
 * For example, the createSelectSql() method checks the type of a given column used in an
 * ORDER BY clause to know whether it needs to apply SQL to make the ORDER BY case-insensitive
 * (i.e. if it's a text column type).
 *
 * @package    workflow.classes.model.map
 */
class HrEmployeeMapBuilder {

	/**
	 * The (dot-path) name of this class
	 */
	const CLASS_NAME = 'classes.model.map.HrEmployeeMapBuilder';

	/**
	 * The database map.
	 */
	private $dbMap;

	/**
	 * Tells us if this DatabaseMapBuilder is built so that we
	 * don't have to re-build it every time.
	 *
	 * @return     boolean true if this DatabaseMapBuilder is built, false otherwise.
	 */
	public function isBuilt()
	{
		return ($this->dbMap !== null);
	}

	/**
	 * Gets the databasemap this map builder built.
	 *
	 * @return     the databasemap
	 */
	public function getDatabaseMap()
	{
		return $this->dbMap;
	}

	/**
	 * The doBuild() method builds the DatabaseMap
	 *
	 * @return     void
	 * @throws     PropelException
	 */
	public function doBuild()
	{
		$this->dbMap = Propel::getDatabaseMap('workflow');

		$tMap = $this->dbMap->addTable('HR_EMPLOYEE');
		$tMap->setPhpName('HrEmployee');

		$tMap->setUseIdGenerator(false);

		$tMap->addPrimaryKey('EMPLOYEE_UID', 'EmployeeUid', 'string', CreoleTypes::VARCHAR, true, 32);

		$tMap->addColumn('EMPLOYEEFIRSTNAME', 'Employeefirstname', 'string', CreoleTypes::VARCHAR, true, 50);

		$tMap->addColumn('EMPLOYEEMIDDLENAME', 'Employeemiddlename', 'string', CreoleTypes::VARCHAR, false, 50);

		$tMap->addColumn('EMPLOYEELASTNAME', 'Employeelastname', 'string', CreoleTypes::VARCHAR, true, 50);

		$tMap->addColumn('EMPLOYEECALLEDNAME', 'Employeecalledname', 'string', CreoleTypes::VARCHAR, true, 50);

		$tMap->addColumn('EMPLOYEEPREFIX_ID', 'EmployeeprefixId', 'string', CreoleTypes::VARCHAR, true, 32);

		$tMap->addColumn('EMPLOYEESUFFIX_ID', 'EmployeesuffixId', 'string', CreoleTypes::VARCHAR, true, 32);

		$tMap->addColumn('EMPLOYEEWORKEMAIL', 'Employeeworkemail', 'string', CreoleTypes::VARCHAR, false, 255);

		$tMap->addColumn('EMPLOYEEPERSONALEMAIL', 'Employeepersonalemail', 'string', CreoleTypes::VARCHAR, false, 255);

		$tMap->addColumn('EMPLOYEEHOMEPHONE', 'Employeehomephone', 'string', CreoleTypes::VARCHAR, false, 20);

		$tMap->addColumn('EMPLOYEEMOBILEPHONE', 'Employeemobilephone', 'string', CreoleTypes::VARCHAR, false, 20);

		$tMap->addColumn('EMPLOYEEWEBPAGE', 'Employeewebpage', 'string', CreoleTypes::VARCHAR, false, 255);

		$tMap->addColumn('EMPLOYEEGENDER_ID', 'EmployeegenderId', 'string', CreoleTypes::VARCHAR, true, 32);

		$tMap->addColumn('EMPLOYEEDATEOFBIRTH', 'Employeedateofbirth', 'int', CreoleTypes::DATE, false, null);

		$tMap->addColumn('EMPLOYEESTATE_ID', 'EmployeestateId', 'string', CreoleTypes::VARCHAR, false, 255);

		$tMap->addColumn('EMPLOYEESSN', 'Employeessn', 'string', CreoleTypes::VARCHAR, true, 11);

		$tMap->addColumn('EMPLOYEEPICTURE', 'Employeepicture', 'string', CreoleTypes::VARCHAR, true, 255);

		$tMap->addColumn('EMPLOYEEISHISPANIC', 'Employeeishispanic', 'int', CreoleTypes::TINYINT, false, null);

		$tMap->addColumn('EMPLOYEEISASIAN', 'Employeeisasian', 'int', CreoleTypes::TINYINT, false, null);

		$tMap->addColumn('EMPLOYEEISAFRICANAMERICAN', 'Employeeisafricanamerican', 'int', CreoleTypes::TINYINT, false, null);

		$tMap->addColumn('EMPLOYEEISAMERICANINDIAN', 'Employeeisamericanindian', 'int', CreoleTypes::TINYINT, false, null);

		$tMap->addColumn('EMPLOYEEISALASKANATIVE', 'Employeeisalaskanative', 'int', CreoleTypes::TINYINT, false, null);

		$tMap->addColumn('EMPLOYEEISHAWAIIANOROTHERPACIFICISLANDER', 'Employeeishawaiianorotherpacificislander', 'int', CreoleTypes::TINYINT, false, null);

		$tMap->addColumn('EMPLOYEEISWHITE', 'Employeeiswhite', 'int', CreoleTypes::TINYINT, false, null);

		$tMap->addColumn('DISTRICT_ID', 'DistrictId', 'string', CreoleTypes::VARCHAR, true, 32);

		$tMap->addColumn('DISTRICTPHONE', 'Districtphone', 'string', CreoleTypes::VARCHAR, false, 20);

		$tMap->addColumn('DISTRICTEXTENSION', 'Districtextension', 'string', CreoleTypes::VARCHAR, false, 10);

		$tMap->addColumn('HOMEPHONEUNLISTED', 'Homephoneunlisted', 'string', CreoleTypes::VARCHAR, false, 20);

		$tMap->addColumn('MARITALSTATUS_ID', 'MaritalstatusId', 'string', CreoleTypes::VARCHAR, true, 32);

		$tMap->addColumn('SUBDAYS', 'Subdays', 'int', CreoleTypes::INTEGER, true, null);

		$tMap->addColumn('OSDIDISTRICTCODE', 'Osdidistrictcode', 'string', CreoleTypes::VARCHAR, true, 20);

		$tMap->addColumn('DIRECTDEPOST', 'Directdepost', 'int', CreoleTypes::TINYINT, false, null);

		$tMap->addColumn('RETIREMENTELIGIBLE', 'Retirementeligible', 'int', CreoleTypes::TINYINT, false, null);

		$tMap->addColumn('HANDICAPSTATUS', 'Handicapstatus', 'int', CreoleTypes::TINYINT, false, null);

		$tMap->addColumn('MULTILINGUAL', 'Multilingual', 'int', CreoleTypes::TINYINT, false, null);

		$tMap->addColumn('REPORTTOEMIS', 'Reporttoemis', 'int', CreoleTypes::TINYINT, false, null);

		$tMap->addColumn('ODHSREPORTED', 'Odhsreported', 'int', CreoleTypes::TINYINT, false, null);

		$tMap->addColumn('EMISEMPLOYEEID', 'Emisemployeeid', 'string', CreoleTypes::VARCHAR, true, 50);

		$tMap->addColumn('EMAILDIRECTDEPOST', 'Emaildirectdepost', 'int', CreoleTypes::TINYINT, false, null);

		$tMap->addColumn('USER_ID', 'UserId', 'string', CreoleTypes::VARCHAR, true, 32);

		$tMap->addColumn('BOARDHIREDATE', 'Boardhiredate', 'int', CreoleTypes::DATE, false, null);

		$tMap->addColumn('FBIBGCHECKDATE', 'Fbibgcheckdate', 'int', CreoleTypes::DATE, false, null);

		$tMap->addColumn('BCIBGCHECKDATE', 'Bcibgcheckdate', 'int', CreoleTypes::DATE, false, null);

		$tMap->addColumn('TBTESTDATE', 'Tbtestdate', 'int', CreoleTypes::DATE, false, null);

		$tMap->addColumn('OVRBGCHECKDATE', 'Ovrbgcheckdate', 'int', CreoleTypes::DATE, false, null);

		$tMap->addColumn('CPIDATE', 'Cpidate', 'int', CreoleTypes::DATE, false, null);

		$tMap->addColumn('HQTEACHER', 'Hqteacher', 'int', CreoleTypes::TINYINT, false, null);

		$tMap->addColumn('OUTOFSTATEEXPERIENCE', 'Outofstateexperience', 'int', CreoleTypes::TINYINT, false, null);

		$tMap->addColumn('INOFSTATEPUBEXPERIENCE', 'Inofstatepubexperience', 'int', CreoleTypes::TINYINT, false, null);

		$tMap->addColumn('INOFSTATENONPUBEXPERIENCE', 'Inofstatenonpubexperience', 'int', CreoleTypes::TINYINT, false, null);

		$tMap->addColumn('INDISTRICTEXPERIENCE', 'Indistrictexperience', 'int', CreoleTypes::TINYINT, false, null);

		$tMap->addColumn('MILITARYTIME', 'Militarytime', 'int', CreoleTypes::TINYINT, false, null);

		$tMap->addColumn('PURCHASEDSERVICECREDIT', 'Purchasedservicecredit', 'int', CreoleTypes::TINYINT, false, null);

	} // doBuild()

} // HrEmployeeMapBuilder
